Transit Route Recs

Plot the transit route's line geom.

/opt/conda/lib/python3.10/site-packages/geopandas/_compat.py:112: UserWarning: The Shapely GEOS version (3.10.3-CAPI-1.16.1) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow.
  warnings.warn(

District 01 - Eureka

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	261	120	0.200
1	159	2042	0.071
2	18	1	0.000
3	18	18689	0.000
4	18	33023	0.000
5	18	8	0.000
6	18	822	0.000
7	159	2017	0.000
8	159	2031	0.000
9	159	2033	0.000
10	159	2041	0.000
11	261	116	0.000
12	261	117	0.000
13	261	118	0.000

District 02 - Redding

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	344	178	0.25
1	82	153	0.00
2	82	157	0.00
3	82	161	0.00
4	82	1885	0.00
5	82	1886	0.00
6	82	1887	0.00
7	82	6446	0.00
8	82	6460	0.00
9	82	6790	0.00
10	162	552	0.00
11	162	554	0.00
12	344	181	0.00
13	344	288	0.00

District 03 - Marysville

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	331	ML	0.222
1	376	474	0.167
2	251	11115	0.067
3	273	015	0.054
4	48	9e53fec4-40e0-4b85-8984-fc8f9c4fae97	0.042
5	48	405c1242-7e26-4b0d-b071-8d82d8ea1675	0.040
6	48	3bea0a4c-dc0f-493c-869e-97d6e8384cd2	0.000
7	372	46c8ab4f-27df-422a-b0b5-9c50275c2588	0.000
8	372	07320499-ab75-48c5-99c7-5967c4b22f1b	0.000
9	372	1b9912ea-a0f8-46d1-a45b-768dbbc96187	0.000
10	372	1c17bb5c-1a20-4427-a01f-d5158c5cc5e2	0.000
11	372	3bc003ec-9243-4b49-a873-e0884b5e6ff7	0.000
12	372	ad7444fd-3e73-4a75-b2dc-68413b6dc649	0.000
13	372	8bebc5d1-8c71-4646-9b43-6513d4589bae	0.000
14	331	Hwy267	0.000
15	372	b6e92239-4632-47de-8ef8-2515e1ef4b1e	0.000
16	372	f7e6fe88-8770-4143-886b-333f0aa0a498	0.000
17	376	472	0.000
18	376	473	0.000
19	376	6463	0.000
20	331	Hwy89	0.000
21	273	210	0.000
22	273	226	0.000
23	251	11121	0.000
24	48	4d36ef15-19a7-45ee-bbb1-f4a4a59535ab	0.000
25	48	9a811a91-b5fb-46cb-b5d9-cb197ce54762	0.000
26	48	ab418467-7749-4421-8043-6a0edbb22098	0.000
27	48	ce46f4b9-eec4-4a83-bd50-50ac486428db	0.000
28	251	11117	0.000
29	251	11119	0.000
30	273	103	0.000
31	273	211	0.000
32	273	109	0.000
33	273	138	0.000
34	273	171	0.000
35	273	174	0.000
36	273	180	0.000
37	273	182	0.000
38	376	6464	0.000

District 04 - Oakland

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	368	J	0.245
1	127	172	0.222
2	194	2303	0.217
3	290	278-196	0.214
4	290	278	0.214
...	...	...	...
98	70	1050	0.000
99	70	1031	0.000
100	70	1029	0.000
101	70	1028	0.000
102	368	Lynx	0.000

103 rows × 3 columns

District 04 - Oakland

Lowest mean speed mph

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	mean_speed_mph
0	4	19	8.44
1	4	72M	9.50
2	4	1T	10.02
3	4	72	10.32
4	4	10	10.61
5	4	72R	11.31
6	127	114	11.99
7	218	S	12.01
8	4	667	13.42
9	127	132	13.56
10	4	631	13.78
11	4	802	14.02
12	4	676	14.21
13	218	11X	14.53
14	218	10	15.68
15	4	682	15.77
16	4	604	16.12
17	127	130	16.32
18	4	232	16.33
19	4	606	16.62
20	4	G	17.04
21	4	FS	17.27
22	127	154-234	17.88
23	4	L	18.29
24	127	150-234	18.85
25	4	W	19.06
26	4	LA	19.24
27	4	O	19.56
28	4	NX	19.75

District 05 - San Luis Obispo

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	296	69A	0.250
1	208	093	0.200
2	208	084	0.200
3	208	092	0.200
4	208	091	0.200
5	289	9N	0.188
6	289	9S	0.167
7	473	65513	0.167
8	296	17	0.133
9	296	91X	0.067
10	296	69W	0.065
11	296	WC	0.000
12	312	ROUTEA	0.000
13	312	ROUTEB	0.000
14	296	79	0.000
15	296	75	0.000
16	473	63257	0.000
17	296	42	0.000
18	129	3278	0.000
19	289	14S	0.000
20	208	011	0.000
21	289	12S	0.000
22	289	12N	0.000
23	289	10S	0.000
24	289	10N	0.000
25	208	923	0.000
26	208	075	0.000
27	208	028	0.000
28	208	023	0.000
29	208	020	0.000
30	289	14N	0.000

District 06 - Fresno

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	146	1368	0.250
1	346	12182	0.250
2	146	1167	0.167
3	146	1367	0.167
4	146	1163	0.154
5	146	1166	0.154
6	346	12183	0.042
7	126	81	0.000
8	346	12176	0.000
9	474	T11	0.000
10	474	P6	0.000
11	474	C40	0.000
12	346	12187	0.000
13	346	12181	0.000
14	188	577	0.000
15	188	579	0.000
16	188	578	0.000
17	126	92	0.000
18	146	1175	0.000
19	146	1173	0.000
20	146	1162	0.000
21	146	1161	0.000
22	474	T7	0.000

District 07 - Los Angeles

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	231	4778	0.138
1	295	799	0.100
2	231	3404	0.062
3	183	31	0.053
4	183	30	0.042
...	...	...	...
88	183	4278	0.000
89	183	28	0.000
90	183	1524	0.000
91	183	1458	0.000
92	380	11693	0.000

93 rows × 3 columns

District 07 - Los Angeles

Lowest mean speed mph

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	mean_speed_mph
0	183	708	8.44
1	170	175	8.57
2	183	26	8.80
3	170	171	9.50
4	170	174	10.66
5	183	28	11.15
6	183	30	11.25
7	183	858	12.12
8	182	232-13159	12.18
9	183	1524	12.29
10	183	31	12.76
11	183	868	13.18
12	183	856	13.69
13	182	150-13159	13.94
14	183	4291	14.18
15	183	1458	15.56
16	182	177-13159	16.17
17	295	627	16.29
18	183	27	16.40
19	183	869	16.49
20	183	4290	16.49
21	182	487-13159	16.53
22	182	550-13159	16.61
23	182	460-13159	16.72
24	182	501-13159	17.20
25	183	867	17.26
26	182	344-13159	17.49
27	183	4278	17.76
28	183	870	18.66
29	295	799	19.24

District 08 - San Bernardino

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	360	3206	0.238
1	232	10396	0.215
2	232	10415	0.162
3	232	10418	0.100
4	269	79	0.091
5	269	28	0.052
6	269	27	0.032
7	34	11662	0.000
8	360	19747	0.000
9	360	3205	0.000
10	360	3240	0.000
11	360	3220	0.000
12	360	19745	0.000
13	360	3381	0.000
14	360	3382	0.000
15	360	3394	0.000
16	360	19746	0.000
17	269	31	0.000
18	360	19744	0.000
19	360	19739	0.000
20	34	1381	0.000
21	269	206	0.000
22	269	205	0.000
23	269	204	0.000
24	269	200	0.000
25	232	10406	0.000
26	232	10401	0.000
27	34	16684	0.000
28	360	5137	0.000

District 08 - San Bernardino

Lowest mean speed mph

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	mean_speed_mph
0	269	79	15.66
1	269	28	18.04
2	269	27	18.99

District 09 - Bishop

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	99	561	0.25
1	99	562	0.00
2	99	563	0.00
3	99	566	0.00
4	99	765	0.00

District 10 - Stockton

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	343	19	0.182
1	11	570	0.125
2	484	32	0.030
3	11	569	0.000
4	343	972	0.000
5	484	38	0.000
6	484	37	0.000
7	484	34	0.000
8	484	30	0.000
9	484	29	0.000
10	484	28	0.000
11	484	25	0.000
12	484	24	0.000
13	484	20	0.000
14	484	19	0.000
15	484	17	0.000
16	343	958	0.000
17	343	1881	0.000
18	343	1211	0.000
19	343	1210	0.000
20	284	95	0.000
21	284	91	0.000
22	284	90	0.000
23	284	163	0.000
24	284	152	0.000
25	284	150	0.000
26	11	661	0.000
27	11	573	0.000
28	11	571	0.000
29	484	4	0.000

District 10 - Stockton

Lowest mean speed mph

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	mean_speed_mph
0	484	28	10.42
1	484	4	12.87
2	484	17	12.99
3	484	20	14.75

District 11 - San Diego

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	278	905	0.082
1	278	25	0.077
2	278	235	0.038
3	278	110	0.000
4	278	894	0.000
5	278	974	0.000
6	278	950	0.000
7	278	904	0.000
8	278	901	0.000
9	278	60	0.000
10	278	816	0.000
11	278	140	0.000
12	278	290	0.000
13	278	280	0.000
14	278	225	0.000
15	278	20	0.000
16	386	21	0.000

District 12 - Irvine

Lowest pct trips competitive

Make this Notebook Trusted to load map: File -> Trust Notebook

	calitp_itp_id	route_id	pct_trips_competitive
0	142	89	0.111
1	142	29	0.044
2	142	529	0.000
3	142	83	0.000